<#assign prefixName = 'WHERE'>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__beginDate??)>
	<#if (where__and__eq__beginDate__value??)>
${prefixName} T.BEGIN_DATE = :where__and__eq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__and__nq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__and__like__beginDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__beginDate__value??)>
${prefixName} T.BEGIN_DATE = :where__or__eq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__or__nq__beginDate__value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__beginDate__value??)>
${prefixName} T.BEGIN_DATE <> :where__or__like__beginDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__code??)>
	<#if (where__and__eq__code__value??)>
${prefixName} T.CODE = :where__and__eq__code__value
	<#else>
${prefixName} T.CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__code??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__code__value??)>
${prefixName} T.CODE <> :where__and__nq__code__value
	<#else>
${prefixName} T.CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__code??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__code__value??)>
${prefixName} T.CODE <> :where__and__like__code__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__code??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__code__value??)>
${prefixName} T.CODE = :where__or__eq__code__value
	<#else>
${prefixName} T.CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__code??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__code__value??)>
${prefixName} T.CODE <> :where__or__nq__code__value
	<#else>
${prefixName} T.CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__code??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__code__value??)>
${prefixName} T.CODE <> :where__or__like__code__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__dataOption??)>
	<#if (where__and__eq__dataOption__value??)>
${prefixName} T.DATA_OPTION = :where__and__eq__dataOption__value
	<#else>
${prefixName} T.DATA_OPTION IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__dataOption??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__dataOption__value??)>
${prefixName} T.DATA_OPTION <> :where__and__nq__dataOption__value
	<#else>
${prefixName} T.DATA_OPTION IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__dataOption??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__dataOption__value??)>
${prefixName} T.DATA_OPTION <> :where__and__like__dataOption__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__dataOption??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__dataOption__value??)>
${prefixName} T.DATA_OPTION = :where__or__eq__dataOption__value
	<#else>
${prefixName} T.DATA_OPTION IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__dataOption??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__dataOption__value??)>
${prefixName} T.DATA_OPTION <> :where__or__nq__dataOption__value
	<#else>
${prefixName} T.DATA_OPTION IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__dataOption??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__dataOption__value??)>
${prefixName} T.DATA_OPTION <> :where__or__like__dataOption__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__endDate??)>
	<#if (where__and__eq__endDate__value??)>
${prefixName} T.END_DATE = :where__and__eq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__endDate__value??)>
${prefixName} T.END_DATE <> :where__and__nq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__endDate__value??)>
${prefixName} T.END_DATE <> :where__and__like__endDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__endDate__value??)>
${prefixName} T.END_DATE = :where__or__eq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__endDate__value??)>
${prefixName} T.END_DATE <> :where__or__nq__endDate__value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__endDate__value??)>
${prefixName} T.END_DATE <> :where__or__like__endDate__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__between__sysdate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'AND'>
</#if>
${prefixName} SYSDATE BETWEEN T.BEGIN_DATE AND T.END_DATE
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__id??)>
	<#if (where__and__eq__id__value??)>
${prefixName} T.ID = :where__and__eq__id__value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__id__value??)>
${prefixName} T.ID <> :where__and__nq__id__value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__id__value??)>
${prefixName} T.ID <> :where__and__like__id__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__id__value??)>
${prefixName} T.ID = :where__or__eq__id__value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__id__value??)>
${prefixName} T.ID <> :where__or__nq__id__value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__id__value??)>
${prefixName} T.ID <> :where__or__like__id__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__name??)>
	<#if (where__and__eq__name__value??)>
${prefixName} T.NAME = :where__and__eq__name__value
	<#else>
${prefixName} T.NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__name??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__name__value??)>
${prefixName} T.NAME <> :where__and__nq__name__value
	<#else>
${prefixName} T.NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__name??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__name__value??)>
${prefixName} T.NAME <> :where__and__like__name__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__name??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__name__value??)>
${prefixName} T.NAME = :where__or__eq__name__value
	<#else>
${prefixName} T.NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__name??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__name__value??)>
${prefixName} T.NAME <> :where__or__nq__name__value
	<#else>
${prefixName} T.NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__name??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__name__value??)>
${prefixName} T.NAME <> :where__or__like__name__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__orderCode??)>
	<#if (where__and__eq__orderCode__value??)>
${prefixName} T.ORDER_CODE = :where__and__eq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__and__nq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__and__like__orderCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__orderCode__value??)>
${prefixName} T.ORDER_CODE = :where__or__eq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__or__nq__orderCode__value
	<#else>
${prefixName} T.ORDER_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__orderCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__orderCode__value??)>
${prefixName} T.ORDER_CODE <> :where__or__like__orderCode__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__siteId??)>
	<#if (where__and__eq__siteId__value??)>
${prefixName} T.SITE_ID = :where__and__eq__siteId__value
	<#else>
${prefixName} T.SITE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__siteId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__siteId__value??)>
${prefixName} T.SITE_ID <> :where__and__nq__siteId__value
	<#else>
${prefixName} T.SITE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__siteId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__siteId__value??)>
${prefixName} T.SITE_ID <> :where__and__like__siteId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__siteId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__siteId__value??)>
${prefixName} T.SITE_ID = :where__or__eq__siteId__value
	<#else>
${prefixName} T.SITE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__siteId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__siteId__value??)>
${prefixName} T.SITE_ID <> :where__or__nq__siteId__value
	<#else>
${prefixName} T.SITE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__siteId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__siteId__value??)>
${prefixName} T.SITE_ID <> :where__or__like__siteId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__target??)>
	<#if (where__and__eq__target__value??)>
${prefixName} T.TARGET = :where__and__eq__target__value
	<#else>
${prefixName} T.TARGET IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__target??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__target__value??)>
${prefixName} T.TARGET <> :where__and__nq__target__value
	<#else>
${prefixName} T.TARGET IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__target??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__target__value??)>
${prefixName} T.TARGET <> :where__and__like__target__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__target??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__target__value??)>
${prefixName} T.TARGET = :where__or__eq__target__value
	<#else>
${prefixName} T.TARGET IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__target??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__target__value??)>
${prefixName} T.TARGET <> :where__or__nq__target__value
	<#else>
${prefixName} T.TARGET IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__target??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__target__value??)>
${prefixName} T.TARGET <> :where__or__like__target__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where__and__eq__typeId??)>
	<#if (where__and__eq__typeId__value??)>
${prefixName} T.TYPE_ID = :where__and__eq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__nq__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__nq__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__and__nq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__and__like__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where__and__like__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__and__like__typeId__value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__eq__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__eq__typeId__value??)>
${prefixName} T.TYPE_ID = :where__or__eq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__nq__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__nq__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__or__nq__typeId__value
	<#else>
${prefixName} T.TYPE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where__or__like__typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where__or__like__typeId__value??)>
${prefixName} T.TYPE_ID <> :where__or__like__typeId__value
	</#if>
	<#assign prefixName = ''>
</#if>
